<?php
$query = $this->db->query('SELECT username, password, email FROM Users');

foreach ($query->result() as $row)
{
    echo $row->username;
    echo $row->password;
    echo $row->email;
}

echo 'Total Results: ' . $query->num_rows();

?>
